CREATE TABLE [dbo].[DISC_Fulfillment]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[distID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[usersID] [varchar] (254) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ordersID] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ordersitemID] [int] NOT NULL,
[fileName] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fileSize] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[netPrice] [decimal] (18, 2) NOT NULL,
[datetime] [datetime] NOT NULL,
[fulfilled] [bit] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DISC_Fulfillment] ADD CONSTRAINT [PK_DISC_Fulfillment] PRIMARY KEY CLUSTERED  ([ID]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
